Query Progress Indicator for Open Source Database
نویسندگان
چکیده
Nowadays mostly database applications are based on long-running and complex queries. So it will be helpful for users to have information about progress of query execution. Recently development of percent done progress indicators has been increased. For this purpose in this paper we propose such progress indicator for multiple concurrently running queries. The main focus is on providing progress indicator for Postgres database.
منابع مشابه
Adaptive Progress Indicator for Long Running SQL Queries
Percent-done progress indicators are a technique for graphically showing how much of a long task has been completed. In the database environment such information is especially important during the long-running query execution. The proposed method constructs (during the learning phase) adaptive progress indicator model analyzing influence of averaged system state (represented with attributes des...
متن کاملMulti-query SQL Progress Indicators
Recently, progress indicators have been proposed for SQL queries in RDBMSs. All previously proposed progress indicators consider each query in isolation, ignoring the impact simultaneously running queries have on each other’s performance. In this paper, we explore a multi-query progress indicator, which explicitly considers concurrently running queries and even queries predicted to arrive in th...
متن کاملSampling-Based Cardinality Estimation Algorithms: A Survey and An Empirical Evaluation
Cardinality estimation is a fundamental problem that has been studied for several decades in database community. It has wide applications in many database management issues such as query optimization, query monitoring, query progress indicator, query execution time prediction, and approximate query answering. Existing cardinality estimation techniques can generally fall into two categories: i) ...
متن کاملAnalysis of User query refinement behavior based on semantic features: user log analysis of Ganj database (IranDoc)
Background and Aim: Information systems cannot be well designed or developed without a clear understanding of needs of users, manner of their information seeking and evaluating. This research has been designed to analyze the Ganj (Iranian research institute of science and technology database) users’ query refinement behaviors via log analysis. Methods: The method of this research is log anal...
متن کاملeXist: An Open Source Native XML Database
With the advent of native and XML enabled database systems, techniques for efficiently storing, indexing and querying large collections of XML documents have become an important research topic. This paper presents the storage, indexing and query processing architecture of eXist, an Open Source native XML database system. eXist is tightly integrated with existing tools and covers most of the nat...
متن کامل